MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

1 row where Artist Role = 974

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ Object Number Is Highlight Is Public Domain Object ID Department Object Name Title Culture Period Dynasty Reign Portfolio Artist Role Artist Prefix Artist Display Name Artist Display Bio Artist Suffix Artist Alpha Sort Artist Nationality Artist Begin Date Artist End Date Object Date Object Begin Date Object End Date Medium Dimensions Credit Line Geography Type City State County Country Region Subregion Locale Locus Excavation River Classification Rights and Reproduction Link Resource Metadata Date Repository
206447 206447 17.3.2984 0 0 333791 Drawings and Prints 11 Book 97 The Heads of the Kings of England, Proper for Mr. Rapin's History           Artist and engraver|Sitter|Sitter|Sitter|Sitter|Sitter|Sitter|Sitter|Sitter|Sitter|Sitter|Artist|Artist|Artist|Artist|Artist|Translator|Publisher|Sitter|Sitter|Sitter|Sitter|Sitter|Sitter|Sitter|Sitter|Sitter|Sitter|Sitter|Sitter|Sitter|Sitter|Sitter|Sitter|Sitter|Sitter|Sitter|Sitter|Sitter|Sitter|Sitter|Sitter|Sitter|Sitter|Sitter|Sitter|Sitter|Dedicatee|Sitter|Author 974 After|After|After|After|After George Vertue|William I, King of England and Duke of Normandy|Oliver Cromwell|Philip II|Mary, Queen of Scots|James II, King of England, Scotland and Ireland|Henry VIII, King of England and Ireland|Charles II, King of England|Richard II|Charles I, King of England, Scotland, Wales and Ireland|Richard I|Titian (Tiziano Vecellio)|Sir Godfrey Kneller|Sir Peter Lely (Pieter van der Faes)|Anthony van Dyck|Hans Holbein the Younger|Nicholas Tindal|James, John and Paul Knapton|Egbert, King of Wessex|Alfred the Great|Canute, King of England, Denmark and Norway|William II, King of England|Henry I, King of England|Stephen, King of England|Henry II, King of England|John, King of England|Henry III, King of England|Edward I, King of England|Edward II, King of England|Edward III, King of England|Edward, Prince of Wales [the Black Prince]|Prince John (of Gaunt)|Henry IV, King of England|Henry V, King of England|Prince John (of Lancaster)|Henry VI, King of England|Edward IV, King of England|Edward V, King of England|Richard III|Henry VII, King of England and Lord of Ireland|Edward VI, King of England|Mary I, Queen of England|Henry Stuart, Lord Darnley|James I, King of England, Scotland and Ireland|Henry Frederick, Prince of Wales|Princess Elizabeth Stuart (later Queen of Bohemia)|Prince Henry, Duke of Gloucester|Frederick Louis, Prince of Wales|Elizabeth I, Queen of England|Paul de Rapin de Thoyras British, London 1684–1756|Falaise 1027/28–1087 St. Gervais, Rouen|British, Huntingdon 1599–1658 London|Spanish, Valladolid 1527–1598 San Lorenzo de El Escorial|Linlithgow 1542–1587 Fotheringhay, England|British, London 1633–1701 France|British, London 1491–1547 London|London 1630–1685 London|British, Bordeaux 1367–1400 London|British, Dunfermline, Scotland 1600–1649 London|British, Oxford, 1157–1199|Italian, Pieve di Cadore ca. 1485/90?–1576 Venice|German, Lübeck 1646–1723 London|British, Soest 1618–1680 London|Flemish, Antwerp 1599–1641 London|German, Augsburg 1497/98–1543 London|British, Plymouth 1687–1774 London|London|died 839|848/849–899|Anglo-Dane, died 1035|ca. 1060–1100|Selby (?) 1068/69–1135 Lyons-la-Forêt, Normandy|ca. 1092–1154|Le Mans 1133–1189 Chinon|Oxford 1167–1216 Newark-on-Trent|Winchester, 1207–1272|Westminster 1239–1307 Burgh by Sands|Caernarfon, Wales 1284–1327 Gloucestershire|Windsor 1312–1377 Sheen|Woodstock 1330–1376 Westminster|British, Ghent 1340–1399 Leicester|Bolingbroke 1366–1413 London|Monmouth, Wales 1386/87–1422 Vincennes, France|British, 1389–1435 Rouen, France|Windsor 1421–1471 London|Rouen, Normandy 1442–1483|London 1470–1483 London|British, Fotheringhay 1452–1485 Leicestershire|British, Pembrokeshire, Wales 1457–1509 Richmond|Hampton 1537–1553 Greenwich|Greenwich 1516–1558 London|British, Yorkshire 1545/46–1567 Edinburgh|Edinburgh 1566–1625 Theobalds|British, Stirling, Scotland 1594–1612 London|Falkland, Scotland 1596–1662 London|British, Surrey 1640–1660 London|British, Hanover 1707–1751 London|1533–1603|French, Castres, France 1661–1725 Wesel, Germany   Vertue, George|William I, King of England|Cromwell, Oliver|Philip II|Mary Queen of Scots|James II, King of England, Scotland and Ireland|Henry VIII, King of England and Ireland|Charles II, King of England|Richard II|Charles I, King of England, Scotland, Wales and Ireland|Richard I|Titian (Tiziano Vecellio)|Kneller, Godfrey, Sir|Lely, Peter, Sir (Pieter van der Faes)|Dyck, Anthony van|Holbein, Hans, the Younger|Tindal, Nicholas|Knapton James, John and Paul|Egbert, King of Wessex|Alfred the Great|Canute, King of England, Denmark and Norway|William II, King of England|Henry I, King of England|Stephen, King of England|Henry II, King of England|John, King of England|Henry III, King of England|Edward I, King of England|Edward II, King of England|Edward III, King of England|Edward, Prince of Wales [the Black Prince]|John (of Gaunt), Prince|Henry IV, King of England|Henry V, King of England|John, (of Lancaster) Prince|Henry VI, King of England|Edward IV, King of England|Edward V, King of England|Richard III|Henry VII, King of England and Lord of Ireland|Edward VI, King of England|Mary I, Queen of England|Stuart, Henry Lord Darnley|James I, King of England and Scotland|Henry, Frederick, Prince of Wales|Elizabeth Stuart, Princess|Henry, Duke of Gloucester, Prince|Frederick Louis, Prince of Wales|Elizabeth I|Rapin, de Thoyras Paul de 17304 British|British|British|Scottish|British|British|British|British|British|British|Italian|German|Dutch, British|Flemish|German|British|British|British|British|British|British|British|British|British|British|British|British|British|British|British|British|British|British|British|British|British|British|British|British|British|British|British|British|British, Scottish|British|British|British|British|French 741 1684 |1599 |1527 |1542 |1633 |1491 |1630 |1367 |1600 |1157 |1485 |1646 |1618 |1599 |1497 |1687 |1700 |0739 |0848 |0935 |1000 |1068 |1090 |1133 |1167 |1207 |1239 |1284 |1312 |1330 |1340 |1366 |1386 |1389 |1421 |1442 |1470 |1452 |1457 |1537 |1516 |1545 |1566 |1594 |1596 |1640 |1707 |1533 |1661 1756 |1027 |1658 |1598 |1587 |1701 |1547 |1685 |1400 |1649 |1199 |1576 |1723 |1680 |1641 |1543 |1774 |1799 |0839 |0899 |1035 |1100 |1135 |1154 |1189 |1216 |1272 |1307 |1327 |1377 |1376 |1399 |1413 |1422 |1435 |1471 |1483 |1483 |1485 |1509 |1553 |1558 |1567 |1625 |1612 |1662 |1660 |1751 |1603 |1725 1736 1736 1736 Illustrations: engraving 28942 20 15/16 x 14 3/16 x 1 in. (53.2 x 36 x 2.5cm) Harris Brisbane Dick Fund, 1917                       Books 442   http://www.metmuseum.org/art/collection/search/333791 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE "MetObjects" (
"Object Number" TEXT,
  "Is Highlight" INTEGER,
  "Is Public Domain" INTEGER,
  "Object ID" INTEGER,
  "Department" INTEGER,
  "Object Name" INTEGER,
  "Title" TEXT,
  "Culture" INTEGER,
  "Period" REAL,
  "Dynasty" INTEGER,
  "Reign" INTEGER,
  "Portfolio" INTEGER,
  "Artist Role" INTEGER,
  "Artist Prefix" REAL,
  "Artist Display Name" TEXT,
  "Artist Display Bio" TEXT,
  "Artist Suffix" REAL,
  "Artist Alpha Sort" INTEGER,
  "Artist Nationality" INTEGER,
  "Artist Begin Date" TEXT,
  "Artist End Date" TEXT,
  "Object Date" TEXT,
  "Object Begin Date" INTEGER,
  "Object End Date" INTEGER,
  "Medium" INTEGER,
  "Dimensions" TEXT,
  "Credit Line" TEXT,
  "Geography Type" INTEGER,
  "City" INTEGER,
  "State" INTEGER,
  "County" INTEGER,
  "Country" INTEGER,
  "Region" INTEGER,
  "Subregion" INTEGER,
  "Locale" INTEGER,
  "Locus" INTEGER,
  "Excavation" INTEGER,
  "River" INTEGER,
  "Classification" INTEGER,
  "Rights and Reproduction" REAL,
  "Link Resource" TEXT,
  "Metadata Date" TEXT,
  "Repository" INTEGER
,
FOREIGN KEY ("Department") REFERENCES [Department](id),
    FOREIGN KEY ("Object Name") REFERENCES [Object Name](id),
    FOREIGN KEY ("Culture") REFERENCES [Culture](id),
    FOREIGN KEY ("Dynasty") REFERENCES [Dynasty](id),
    FOREIGN KEY ("Reign") REFERENCES [Reign](id),
    FOREIGN KEY ("Portfolio") REFERENCES [Portfolio](id),
    FOREIGN KEY ("Artist Role") REFERENCES [Artist Role](id),
    FOREIGN KEY ("Artist Alpha Sort") REFERENCES [Artist Alpha Sort](id),
    FOREIGN KEY ("Artist Nationality") REFERENCES [Artist Nationality](id),
    FOREIGN KEY ("Medium") REFERENCES [Medium](id),
    FOREIGN KEY ("Geography Type") REFERENCES [Geography Type](id),
    FOREIGN KEY ("City") REFERENCES [City](id),
    FOREIGN KEY ("State") REFERENCES [State](id),
    FOREIGN KEY ("County") REFERENCES [County](id),
    FOREIGN KEY ("Country") REFERENCES [Country](id),
    FOREIGN KEY ("Region") REFERENCES [Region](id),
    FOREIGN KEY ("Subregion") REFERENCES [Subregion](id),
    FOREIGN KEY ("Locale") REFERENCES [Locale](id),
    FOREIGN KEY ("Locus") REFERENCES [Locus](id),
    FOREIGN KEY ("Excavation") REFERENCES [Excavation](id),
    FOREIGN KEY ("River") REFERENCES [River](id),
    FOREIGN KEY ("Classification") REFERENCES [Classification](id),
    FOREIGN KEY ("Repository") REFERENCES [Repository](id));
CREATE INDEX ["MetObjects_Department"] ON [MetObjects]("Department");
CREATE INDEX ["MetObjects_Object Name"] ON [MetObjects]("Object Name");
CREATE INDEX ["MetObjects_Culture"] ON [MetObjects]("Culture");
CREATE INDEX ["MetObjects_Dynasty"] ON [MetObjects]("Dynasty");
CREATE INDEX ["MetObjects_Reign"] ON [MetObjects]("Reign");
CREATE INDEX ["MetObjects_Portfolio"] ON [MetObjects]("Portfolio");
CREATE INDEX ["MetObjects_Artist Role"] ON [MetObjects]("Artist Role");
CREATE INDEX ["MetObjects_Artist Alpha Sort"] ON [MetObjects]("Artist Alpha Sort");
CREATE INDEX ["MetObjects_Artist Nationality"] ON [MetObjects]("Artist Nationality");
CREATE INDEX ["MetObjects_Medium"] ON [MetObjects]("Medium");
CREATE INDEX ["MetObjects_Geography Type"] ON [MetObjects]("Geography Type");
CREATE INDEX ["MetObjects_City"] ON [MetObjects]("City");
CREATE INDEX ["MetObjects_State"] ON [MetObjects]("State");
CREATE INDEX ["MetObjects_County"] ON [MetObjects]("County");
CREATE INDEX ["MetObjects_Country"] ON [MetObjects]("Country");
CREATE INDEX ["MetObjects_Region"] ON [MetObjects]("Region");
CREATE INDEX ["MetObjects_Subregion"] ON [MetObjects]("Subregion");
CREATE INDEX ["MetObjects_Locale"] ON [MetObjects]("Locale");
CREATE INDEX ["MetObjects_Locus"] ON [MetObjects]("Locus");
CREATE INDEX ["MetObjects_Excavation"] ON [MetObjects]("Excavation");
CREATE INDEX ["MetObjects_River"] ON [MetObjects]("River");
CREATE INDEX ["MetObjects_Classification"] ON [MetObjects]("Classification");
CREATE INDEX ["MetObjects_Repository"] ON [MetObjects]("Repository");
CREATE INDEX metobjects_IsHighlight ON MetObjects("Is Highlight");
CREATE INDEX metobjects_IsPublicDomain ON MetObjects("Is Public Domain");
CREATE INDEX metobjects_Department ON MetObjects("Department");
CREATE INDEX metobjects_Culture ON MetObjects("Culture");
CREATE INDEX metobjects_Period ON MetObjects("Period");
CREATE INDEX metobjects_Dynasty ON MetObjects("Dynasty");
CREATE INDEX metobjects_Medium ON MetObjects("Medium");
CREATE INDEX metobjects_City ON MetObjects("City");
CREATE INDEX metobjects_State ON MetObjects("State");
CREATE INDEX metobjects_County ON MetObjects("County");
CREATE INDEX metobjects_Country ON MetObjects("Country");
CREATE INDEX metobjects_Region ON MetObjects("Region");
CREATE INDEX metobjects_Subregion ON MetObjects("Subregion");
CREATE INDEX metobjects_Locale ON MetObjects("Locale");
CREATE INDEX metobjects_Locus ON MetObjects("Locus");
CREATE INDEX metobjects_Excavation ON MetObjects("Excavation");
CREATE INDEX metobjects_River ON MetObjects("River");
Powered by Datasette · Query took 893.107ms · Data license: CC0 · Data source: metmuseum/openaccess